<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<title>DBTest xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/com/totsp/gwittir/example/client/DBTest.html">View Javadoc</a></div><pre>

<a name="1" href="#1">1</a>   <em class="jxr_comment">/*</em>
<a name="2" href="#2">2</a>   <em class="jxr_comment"> * To change this template, choose Tools | Templates</em>
<a name="3" href="#3">3</a>   <em class="jxr_comment"> * and open the template in the editor.</em>
<a name="4" href="#4">4</a>   <em class="jxr_comment"> */</em>
<a name="5" href="#5">5</a>   <strong class="jxr_keyword">package</strong> com.totsp.gwittir.example.client;
<a name="6" href="#6">6</a>   
<a name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> com.google.gwt.user.client.Window;
<a name="8" href="#8">8</a>   
<a name="9" href="#9">9</a>   <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.jsni.JavaScriptObjectDecorator;
<a name="10" href="#10">10</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.Database;
<a name="11" href="#11">11</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.Databases;
<a name="12" href="#12">12</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.ResultSet;
<a name="13" href="#13">13</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.ResultsCallback;
<a name="14" href="#14">14</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.SQLError;
<a name="15" href="#15">15</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.Transaction;
<a name="16" href="#16">16</a>  <strong class="jxr_keyword">import</strong> com.totsp.gwittir.client.util.html5db.TransactionTask;
<a name="17" href="#17">17</a>  
<a name="18" href="#18">18</a>  
<a name="19" href="#19">19</a>  <em class="jxr_javadoccomment">/**</em>
<a name="20" href="#20">20</a>  <em class="jxr_javadoccomment"> *</em>
<a name="21" href="#21">21</a>  <em class="jxr_javadoccomment"> * @author kebernet</em>
<a name="22" href="#22">22</a>  <em class="jxr_javadoccomment"> */</em>
<a name="23" href="#23">23</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../com/totsp/gwittir/example/client/DBTest.html">DBTest</a> {
<a name="24" href="#24">24</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> doInsert() {
<a name="25" href="#25">25</a>          <a href="../../../../../com/totsp/gwittir/client/util/html5db/Database.html">Database</a> db = Databases.openDatabase(<span class="jxr_string">"gwittir-windowcontext"</span>, <span class="jxr_string">"1.0"</span>,
<a name="26" href="#26">26</a>                  <span class="jxr_string">"This is the gwittir test db"</span>, 512000);
<a name="27" href="#27">27</a>          db.run(<strong class="jxr_keyword">new</strong> <a href="../../../../../com/totsp/gwittir/client/util/html5db/TransactionTask.html">TransactionTask</a>() {
<a name="28" href="#28">28</a>                  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> run(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx) {
<a name="29" href="#29">29</a>                      tx.execute(<span class="jxr_string">"SELECT COUNT(*) FROM Gwittir"</span>, <strong class="jxr_keyword">null</strong>,
<a name="30" href="#30">30</a>                          <strong class="jxr_keyword">new</strong> <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultsCallback.html">ResultsCallback</a>() {
<a name="31" href="#31">31</a>                              <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onSuccess(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx, <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultSet.html">ResultSet</a> rs) {
<a name="32" href="#32">32</a>                                  Window.alert(<span class="jxr_string">"Worked!"</span>);
<a name="33" href="#33">33</a>                                  tx.execute(<span class="jxr_string">"SELECT id, note FROM Gwittir"</span>, <strong class="jxr_keyword">null</strong>,  <strong class="jxr_keyword">new</strong> ResultsCallback(){
<a name="34" href="#34">34</a>  
<a name="35" href="#35">35</a>                              <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onSuccess(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx, <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultSet.html">ResultSet</a> rs) {
<a name="36" href="#36">36</a>                                  <strong class="jxr_keyword">for</strong>(<a href="../../../../../com/totsp/gwittir/client/jsni/JavaScriptObjectDecorator.html">JavaScriptObjectDecorator</a> d: rs.getRows()){
<a name="37" href="#37">37</a>                                      Window.alert( <span class="jxr_string">"Got:  "</span>+d.getIntegerProperty(<span class="jxr_string">"id"</span>)+<span class="jxr_string">" :: "</span>+d.getStringProperty(<span class="jxr_string">"note"</span>));
<a name="38" href="#38">38</a>                                  }
<a name="39" href="#39">39</a>                              }
<a name="40" href="#40">40</a>  
<a name="41" href="#41">41</a>                              <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onFailure(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx, <a href="../../../../../com/totsp/gwittir/client/util/html5db/SQLError.html">SQLError</a> error) {
<a name="42" href="#42">42</a>                                  Window.alert(<span class="jxr_string">"Select failed"</span>);
<a name="43" href="#43">43</a>                              }
<a name="44" href="#44">44</a>  
<a name="45" href="#45">45</a>                                  });
<a name="46" href="#46">46</a>                              }
<a name="47" href="#47">47</a>  
<a name="48" href="#48">48</a>                              <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onFailure(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx, <a href="../../../../../com/totsp/gwittir/client/util/html5db/SQLError.html">SQLError</a> error) {
<a name="49" href="#49">49</a>                                  tx.execute(<span class="jxr_string">"CREATE TABLE Gwittir (id REAL UNIQUE, note TEXT)"</span>,
<a name="50" href="#50">50</a>                                      <strong class="jxr_keyword">null</strong>,
<a name="51" href="#51">51</a>                                      <strong class="jxr_keyword">new</strong> <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultsCallback.html">ResultsCallback</a>() {
<a name="52" href="#52">52</a>                                          <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onSuccess(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx,
<a name="53" href="#53">53</a>                                              <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultSet.html">ResultSet</a> rs) {
<a name="54" href="#54">54</a>                                              Window.alert(<span class="jxr_string">"Database created."</span>);
<a name="55" href="#55">55</a>  
<a name="56" href="#56">56</a>                                              Object[] parameters = <strong class="jxr_keyword">new</strong> Object[2];
<a name="57" href="#57">57</a>                                              parameters[0] = 1;
<a name="58" href="#58">58</a>                                              parameters[1] = <span class="jxr_string">"This is a test of the emergency broadcast system"</span>;
<a name="59" href="#59">59</a>                                              tx.execute(<span class="jxr_string">"INSERT INTO Gwittir (id, note) VALUES (?, ?)"</span>,
<a name="60" href="#60">60</a>                                                  parameters,
<a name="61" href="#61">61</a>                                                  <strong class="jxr_keyword">new</strong> <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultsCallback.html">ResultsCallback</a>() {
<a name="62" href="#62">62</a>                                                      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onSuccess(
<a name="63" href="#63">63</a>                                                          <a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx,
<a name="64" href="#64">64</a>                                                          <a href="../../../../../com/totsp/gwittir/client/util/html5db/ResultSet.html">ResultSet</a> rs) {
<a name="65" href="#65">65</a>                                                          Window.alert(
<a name="66" href="#66">66</a>                                                              <span class="jxr_string">"Insert Succeeded."</span>);
<a name="67" href="#67">67</a>                                                      }
<a name="68" href="#68">68</a>  
<a name="69" href="#69">69</a>                                                      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onFailure(
<a name="70" href="#70">70</a>                                                          <a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx,
<a name="71" href="#71">71</a>                                                          <a href="../../../../../com/totsp/gwittir/client/util/html5db/SQLError.html">SQLError</a> error) {
<a name="72" href="#72">72</a>                                                          Window.alert(
<a name="73" href="#73">73</a>                                                              <span class="jxr_string">"Insert failed."</span>);
<a name="74" href="#74">74</a>                                                      }
<a name="75" href="#75">75</a>                                                  });
<a name="76" href="#76">76</a>                                          }
<a name="77" href="#77">77</a>  
<a name="78" href="#78">78</a>                                          <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onFailure(<a href="../../../../../com/totsp/gwittir/client/util/html5db/Transaction.html">Transaction</a> tx,
<a name="79" href="#79">79</a>                                              <a href="../../../../../com/totsp/gwittir/client/util/html5db/SQLError.html">SQLError</a> error) {
<a name="80" href="#80">80</a>                                              Window.alert(
<a name="81" href="#81">81</a>                                                  <span class="jxr_string">"Error creating database."</span>);
<a name="82" href="#82">82</a>                                          }
<a name="83" href="#83">83</a>                                      });
<a name="84" href="#84">84</a>                              }
<a name="85" href="#85">85</a>                          });
<a name="86" href="#86">86</a>                  }
<a name="87" href="#87">87</a>              });
<a name="88" href="#88">88</a>      }
<a name="89" href="#89">89</a>  }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

